package com.hubu.jwxt.beans;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Grade {
    /*
    CREATE TABLE `grade`  (
  `s_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学生学号',
  `c_id` int(11) NOT NULL COMMENT '课程ID',
  `grade` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '课程分数',
  PRIMARY KEY (`s_num`, `c_id`) USING BTREE,
  INDEX `c_id_g`(`c_id`) USING BTREE,
  CONSTRAINT `c_id_g` FOREIGN KEY (`c_id`) REFERENCES `course` (`c_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `s_num_g` FOREIGN KEY (`s_num`) REFERENCES `student` (`s_num`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;
     */

    private String s_num;
    private int c_id;
    private String grade;
}
